UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z6vGaRISMf1otoxWnUJv2VZITiRjhfbBHMpzVjNqEDo='
WHERE
key_id = 'ccb33b3f7757695d83b51337c77023cf1731605a3c67768f3816aa6e7e2efef7'
AND (
token = 'z6vGaRISMf1otoxWnUJv2VZITiRjhfbBHMpzVjNqEDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)