SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '175e78f52a84fa4ccd79d9e5867c5147defc1e24746e5061b92078e0d90f2f5b' 
  AND token = 'FrcKxfRE0Cy/mL3B1hCzyQjSNOxIpJzGGe0dAs40YdM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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