UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eRu1lCJv28NVtcLq0OFykxGg1wfUliyFOhFTeBTeGSU='
WHERE
key_id = '37f349252867b9838b4b5b6cf09c6932c41741431ed52b07041b1943546ee7fc'
AND (
token = 'eRu1lCJv28NVtcLq0OFykxGg1wfUliyFOhFTeBTeGSU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)