UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9L4tjah7RcA1hj/1+Un0dSSy+zESFxtiDr6V5RfAA54='
WHERE
key_id = 'c2783f5694e46e1c17c67f9d3424c49f24ae5600fa20664faf7e4925618ac260'
AND (
token = '9L4tjah7RcA1hj/1+Un0dSSy+zESFxtiDr6V5RfAA54='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)