UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Y/Zf3j/kOBjW71oJfqXMm9fKnMMGbdetNGiJxd2odRc='
WHERE
key_id = 'c717f686cbc8531728efe87065a83848dac0167e4e435e41245b85344bb757c3'
AND (
token = 'Y/Zf3j/kOBjW71oJfqXMm9fKnMMGbdetNGiJxd2odRc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)