SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '1efeaf7764b50887a0ad061c333a2bed89a5e13e071ebcbb9211116062480e73' 
  AND token = 'TM9i9GHr/1CGU17WdwgIiNgw+IqhjUQBABgFh6mPzCk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00015

JSON explain

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