SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'a307138b1e3d72195838f831b54d1c2a79d601baf421f27b0b32874dc1b80e10' 
  AND token = '2/WCUbxHMMB0SVtxOQ5DZxQmonztXp/srQhSSE5F5Rs=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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