SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '2a78b9de9ab9be6cb5a2235b6b78d4c739153b1cb16f70b82dd189d905610fac' 
  AND token = 'Bon/C8/5/YbrV8gbo/oGZ5pMB5Nq3qeC0kEesDv9zsY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00036

JSON explain

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