UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W/p+Tko7n5+9iRvhVspjrHNHHe/Yq2+Q3VJmyKKiWRI=' 
WHERE 
  key_id = '50371446519be413b8bc5795547c6a496b22046b3421ff03b2b687defb82183e' 
  AND (
    token = 'W/p+Tko7n5+9iRvhVspjrHNHHe/Yq2+Q3VJmyKKiWRI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037