SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '953fce8b6650d8a2b7cc3d388311ecdbcbce603a4d114b7ac696cec170591701' 
  AND token = 'CR/z0fXd9snMJqF83IIGk/eErX92RDvIBuVPs7K5Vls=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00028

JSON explain

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