SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6941cc81c20d1fb89eb8828d80f3744e5250c802ebf1901d0d554e0465b0a9d1' 
  AND token = '7BzkP0e2oDsNegCkiVMbvW1iZSiAUSE5itdOc+ARXhE=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00075

JSON explain

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