SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6d526416778e434534a4b0b9d720b7e5ad877bbbdd2c7925bb2d9890cb253a17' 
  AND token = '+3CNzNcguH/63O5ddrL6Vm8x2qvX2Mam690m/93TK5c=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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