UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pO9f5C9Z4HklaKguOPUh/oPaJ1JN6EYTAHwEQmS4RXw='
WHERE
key_id = '1a21a05a2cb1c98de4e3decdd84f8f9bcd29ec99e5a521f879de53e3fcac4ba2'
AND (
token = 'pO9f5C9Z4HklaKguOPUh/oPaJ1JN6EYTAHwEQmS4RXw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)