SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'e723b6d64370809f0a819b0ee0efb496e92b7b54c08a79eaaa7ee20ed9a0d01e' 
  AND token = 'N2JWI77e+cXb7aauVLA7hlWses3i1P4XbwVt3T3YzaQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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