SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '7f6345daf4e248681021cab2643e62db666666a2e060b14fed4f675719277c38' 
  AND token = 'FYQ1jRrargu0mXBB2em3ft/9y8vb+XAf8EdQ4PPOCmY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00037

JSON explain

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