SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'b9d50292c3713159c7c78d8c2465d6527163409ba87f25d5b1f2f11e06fc3e57' 
  AND token = '9cC9jSvvjJmE48ey0fsfqmAIzGbemBkeu2aQ58X18ck=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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