UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gn+lduWmHYR6j5pcdxwoI/AuG0OvdHOguBDlG3FS+cI='
WHERE
key_id = '3ca222c1c19867ae2d36a382b4861fd286a088d7ecccf646b95ad2ec3228626c'
AND (
token = 'gn+lduWmHYR6j5pcdxwoI/AuG0OvdHOguBDlG3FS+cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)