SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '9d4b7540d71a57bdb0d5c2f381f6bd3013e1f97d92798be646916d66b74d986c' 
  AND token = '+dpQB6Tw8t0Pwp6xHSlhQ5BeB1ohH5ai+oLhDf4hIBQ=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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