UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JSfhPK62LckJsWbBKUYAtPQpkP42upN1lG65dT0Vz1g='
WHERE
key_id = 'd077be9e391c57f43f5a9a9c6ecc52763a637fe2256ab3eb9fb378b3e440ebfc'
AND (
token = 'JSfhPK62LckJsWbBKUYAtPQpkP42upN1lG65dT0Vz1g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)