UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'BKIZv0+OXJ+Zog0tnHvsFM1RWJHJBSB82pM3MWe8FWE=' 
WHERE 
  key_id = '41e66b092f42a594b5f66fe61064084f07ec1d40c2718575ff3c0bf18934ab7b' 
  AND (
    token = 'BKIZv0+OXJ+Zog0tnHvsFM1RWJHJBSB82pM3MWe8FWE=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00019