UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qnUzzpgfqSxvudIRYSvkOB34a+RF/n6ijwzBfRd7Wi8='
WHERE
key_id = '974cfb5564c5571fbe3b3a1d6fbe7d4f21364b34aa46e19127fa8f962edcdf5a'
AND (
token = 'qnUzzpgfqSxvudIRYSvkOB34a+RF/n6ijwzBfRd7Wi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)