UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EP4CkriDLH0RPkUPqnxUNqCRSWAB1yOujK1hl88RrWU='
WHERE
key_id = '226c7c308645d8c719756e849c223a59b88213ea4ca391fb39b925a66a1e9cc1'
AND (
token = 'EP4CkriDLH0RPkUPqnxUNqCRSWAB1yOujK1hl88RrWU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)