UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'foHTIxH0e+bBQkhbZtlvG4BchDq90JGeslYCzpKO+1Q='
WHERE
key_id = 'a82ec2be8f2ce79e59399386a5ca203657d703e5d87af56a0ec543cf9f2afd6b'
AND (
token = 'foHTIxH0e+bBQkhbZtlvG4BchDq90JGeslYCzpKO+1Q='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)