UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VvHCJzoWbk/Tk7R8yrcnNQV21FtCnODG1/rketD9IfI='
WHERE
key_id = 'bc2839bd01bd582e54794ff9090de196c37ce2a7e511aaa735d6cd0cead8c8fb'
AND (
token = 'VvHCJzoWbk/Tk7R8yrcnNQV21FtCnODG1/rketD9IfI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)