UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RH87iQQm6shAMrTY/bfY1tCMkmJe7NZZHEGcyZ5jko0='
WHERE
key_id = '8a7e3162ae5b123b2353b7920e116d3a4e0376b256780fed83d26bc7ca74afe1'
AND (
token = 'RH87iQQm6shAMrTY/bfY1tCMkmJe7NZZHEGcyZ5jko0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)