UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WRiAf6e4/iVv14jD7ACs3kFKY7ZFA9U6JF1F9xJZ0Z0='
WHERE
key_id = 'd040aa8da7852ac68832cb2debae7eb825dfdb3238bd20f4a439eb3a5b0f9caf'
AND (
token = 'WRiAf6e4/iVv14jD7ACs3kFKY7ZFA9U6JF1F9xJZ0Z0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)