SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '785df3e4d4cfe462e90f64a215b58c0190b80374109e4a75cb04d0563c17ab27' 
  AND token = 'yEU+ugMaXhLhXQt3ktUxrBT/56katXJzSCMjnk1ynC4=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00020

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}