UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R4LzZ9BnVQV0g5HLZ0sVOI5mWeLvcjPBTYAHPyWqniw='
WHERE
key_id = 'b4814cda455795a8255f9be0e54e2e549c844774b669b652f6386099e130e6f7'
AND (
token = 'R4LzZ9BnVQV0g5HLZ0sVOI5mWeLvcjPBTYAHPyWqniw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)