UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pcJJxDJBGaRf+MOqw9Iv8C9LsaC0GE2Xi34rP8fbjU8='
WHERE
key_id = '07710fdbd58e63874ee49eabb9a6fd4f2679b702bf93bf0e38ca979495275101'
AND (
token = 'pcJJxDJBGaRf+MOqw9Iv8C9LsaC0GE2Xi34rP8fbjU8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)