UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBb63StBEGoGEM8Yo6cIvOeSQ19YJy1uV25EIoKzjuU='
WHERE
key_id = '2fbace27ee7c855baebb7d4bae976fe66c27c0692fbf06ea9f641034868b407b'
AND (
token = 'HBb63StBEGoGEM8Yo6cIvOeSQ19YJy1uV25EIoKzjuU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)