UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XWS/88lPDP8JLhMEDMl58jGoBW4QZMF48t8fvV4+w70='
WHERE
key_id = 'e4cb8f780617832cb3f201ff38bb655346be9df82845f836494180cc641badf2'
AND (
token = 'XWS/88lPDP8JLhMEDMl58jGoBW4QZMF48t8fvV4+w70='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)