UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3N1aG4R1TN/4x0m2yZWePrbCxUQ6Jo59HodlX6Spv8o='
WHERE
key_id = 'dce848d1bd4cb0ed5273e3ec93c87cf08987ad12ebc0d01bd58a3f8d03d6f20e'
AND (
token = '3N1aG4R1TN/4x0m2yZWePrbCxUQ6Jo59HodlX6Spv8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)