SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '62543bb7f7eb5a0009431774eb9b64b1737d8bf4fae96358c00d4d7daa0f0074' 
  AND token = 'MBFiINi4p6FopugURNZ0WsmnpF7NamCqSl1dNsD2730=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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