SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '500f288177848645d0098e03c0cca168ced7cacc3379d24be0f3e40e9bed92f1' 
  AND token = 'FnsuFb8iQzSPXmOSDg+bp8cC4dAwjLCCq03fLDH99b0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00035

JSON explain

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