UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C/ZwassC9C1dnEs7NrVGpZvw2o8ZsqMsml7mmMhHIq8='
WHERE
key_id = 'dd7b4284495f44b5c410569c2608a2784b0fcc2eee1feba8f8f4f5a0f33e9147'
AND (
token = 'C/ZwassC9C1dnEs7NrVGpZvw2o8ZsqMsml7mmMhHIq8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)