UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fNjyw1NHzWv2acuTtaerIcn6tKztPmNt9+gxRzs9k50='
WHERE
key_id = 'dc1aac9ff8cb17826f6342c196e2a285b0542be11a2ab4855666d01eea4bf410'
AND (
token = 'fNjyw1NHzWv2acuTtaerIcn6tKztPmNt9+gxRzs9k50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)