UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'FhGQDF3Hl34NZHtVkuiPV+Xgn4KW3rTean6ynwEpzwo='
WHERE
key_id = '730fd6c41d9c6919bae70bc49ee44b9c7204cacf9be1839492543a7787cc95d9'
AND (
token = 'FhGQDF3Hl34NZHtVkuiPV+Xgn4KW3rTean6ynwEpzwo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)