UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Pa59Pl8/JkwQYhCfFaL1QxWf2zrCJ60aK5KLNvNwUnA='
WHERE
key_id = 'a644ef0490c7aff04da9cff3bb4894b54dc482d43d56e3b1b8eb993c204de6b2'
AND (
token = 'Pa59Pl8/JkwQYhCfFaL1QxWf2zrCJ60aK5KLNvNwUnA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)