UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k9hQOGJQBEem+C8ksHoFY7DBI+Mz/jV3I3zB4ZVVD3w='
WHERE
key_id = 'b4efa8e64a68ab2bd6db8ca31d0dba474eb3a7391834e33efb71050278059711'
AND (
token = 'k9hQOGJQBEem+C8ksHoFY7DBI+Mz/jV3I3zB4ZVVD3w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)