UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Shl2WwwRtgzGZRiI2+H+ge1Jx3Wo6PWE/GbKvOLvBog='
WHERE
key_id = 'e7d45f890db3b5aaa776fdb8fea58870e38f075752bccee0ae8f4aa408b63a75'
AND (
token = 'Shl2WwwRtgzGZRiI2+H+ge1Jx3Wo6PWE/GbKvOLvBog='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)