UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LM42Og2HTSxH5aFsCun5iKQQKNPFZSfcjVZbCCPixTE='
WHERE
key_id = '31cd53171be562b22a193e8ae4352aeaac25912e1c88e6e0ae34cd2e7e7ad169'
AND (
token = 'LM42Og2HTSxH5aFsCun5iKQQKNPFZSfcjVZbCCPixTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)