SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'fe9ba37f903b35f427777fbf4865819b78a7cfd06155fa6f2dd5bc99a2e2b874' 
  AND token = 'apxMmArO8D7gFpKBCkKq6/0m1LsB5O0GsnaTqyXEzb0=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00030

JSON explain

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