UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'YCB1V0hBAbFn17/zEuIOzfTO+IoFAEpxcbAbT1+vbcA=' 
WHERE 
  key_id = '80c97b4cb544ce2849e546012c79439babf6f9d2c23585b66ab8c051238dcb11' 
  AND (
    token = 'YCB1V0hBAbFn17/zEuIOzfTO+IoFAEpxcbAbT1+vbcA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030