UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vgDDna40b87OvvnUTRvGOXovP/Rg0rUL6azT28fV5ME='
WHERE
key_id = '5fa534aaa806517a07a83ace3d7b52faa4f1fa2e22c8a1aa5dd5cc8a5560199f'
AND (
token = 'vgDDna40b87OvvnUTRvGOXovP/Rg0rUL6azT28fV5ME='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)